Lucas Rayala
Lucas Rayala
-
Re: Automate Workflow to Refresh 2 Sheets based on adding to another sheet
@Sherry Fox I've been finding that Chat GPT has some seriously solid insight on problems like this. I'm clever, but it would have taken me a day of testing to come up with a solution for this issue. …1 · -
Re: I'd like to create a column formula that references a specific cell with acceptable syntax
@jcabaniss , swap out this: =[Target End Date]1 with this: =Index([Target End Date]:[Target End Date], 1) the second value in an index function is the row—usually we make this a MATCH lookup function…1 · -
Re: INDEX/MATCH/COLLECT How to get most recent entry by person and by most recent date
Sorry, I’m having trouble writing my last comment and I realized you were asking for the most recent, and I gave you the formula for the earliest. Do what I said in the first post but but update this…1 · -
Re: Formula Help - Check the box once per unique ID
@MHalvey -- if you have DataMesh, you could make this checkbox happen with a helper page and no formulas. On your original page, create a RowID column (this will create a generic unique id for each r…1 · -
Re: Find if a word (from a list) is contained in a text
hi @Wethepeople, you can put a formula in Column B of table 1 to collect the salesperson. I'm going to assume the salesperson enters their name somewhere in table2 so you can collect their name: =IND…1 ·
